package com.zz.parkingsystem.mapper;

import com.zz.parkingsystem.dto.InsDTO;
import com.zz.parkingsystem.entity.Inspector;
import com.zz.parkingsystem.vo.AllInsVO;
import com.zz.parkingsystem.vo.BaseInsOrderVO;
import com.zz.parkingsystem.vo.BaseInsVO;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import com.zz.parkingsystem.entity.OrderItem;
import com.zz.parkingsystem.vo.Inspector_SectionVO;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

/**
* @author zz
* @description 针对表【t_inspector(巡查员表)】的数据库操作Mapper
* @createDate 2022-08-30 17:24:59
* @Entity com.zz.parkingsystem.entity.Inspector
*/
@Mapper
@Repository
public interface InspectorMapper {
    int updateInsStatusE(Long id);
    int updateInsStatusJ(Long id);
    List<Inspector> getOrderIns(Long id);
    BaseInsVO getBaseIns(Long id);
    Long getCount(InsDTO insDto);
    List<AllInsVO> getAllInsMes(InsDTO insDto);


    /**
     * 查询所有巡检员
     * 用于路段界面的添加修改
     */
    List queryAllIns();
    int deleteByPrimaryKey(Long id);

    int insert(Inspector record);

    int insertSelective(Inspector record);

    Inspector selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Inspector record);

    int updateByPrimaryKey(Inspector record);

    List<Inspector_SectionVO> getpark_photograph(Long id);

    Inspector_SectionVO getweekday_amount(String oiId);

    Inspector_SectionVO getweekend_amount(String oiId);

    List<Inspector_SectionVO> getLicensePlateCheckOrder( String carLicensePlate);

    List getorder(Long id);

    List getexcOrder(Long id);

    List<Inspector_SectionVO> getspace_UnknownCar(Long id);

    Long getspace_count(Long id);

    Inspector_SectionVO inspector_section(Long id);
    //根据电话查巡检员
    Inspector selectByPrimaryTel(String ins_tel);
    //根据电话和密码登录
    Inspector selectByPrimaryBytelAndpwd(String insTel,String insPassword);
    //根据电话查密码
    Inspector selectByPrimaryByTel(String insTel);
    //巡检员上班打卡
    //巡检员总数量
    int selAllsum();

}
